Displaying the Item Inquiry Screen

You are here: 1. Distribution System > 1.4. SALES Menu: Sales Order Processing > 1.4.2. Sales - Sales Desk Inquiries > 1.4.2.1. Sales Desk Inquiries - Inventory > Displaying the Item Inquiry Screen

Displaying the Item Inquiry Screen

To perform inventory inquiries:

Select SALES | SALES DESK INQUIRIES | INVENTORY.

Micronet displays the Item Selection screen.

Select an existing item.

If you have more than one screen of items, you can use a partial key search. For more information, refer to "Using Partial Key Searches".

Optionally, select to sort the list of items using the options under the SORT menu.

You can sort items by ID, description, category, supplier, debtor parts, alternate supplier, class, barcode, inner barcode, unit barcode 1 or unit barcode 2.

Technical Tip

2.8 Feature

This screen has been expanded in v2.8 to show more item details including whether an item is replenished, the re-order quantity and supplier part numbers. Any warehouse details displayed on this screen, e.g. W/House On Hand or W/House Free Stock, show information for your default warehouse.

Alternatively, escape the Item Selection screen and enter the ID of an existing item.

Technical Tip

You can also scan the barcode of an item you want to inquire on or enter a supplier's alternate part number for the item. In Micronet v2.8, you can enter the item's short code. In all cases, Micronet displays the item information in the Item Inquiry screen.

Micronet displays the Item Inquiry screen with the details of the item you selected. The bottom section of the screen shows the current stock availability of the selected item with the TOTAL of all warehouses shown first.

This screen displays the following details:

	Field	Value
	Item Number	The item number you are inquiring on. You can delete this and press Enter to choose another item number.
	Text	Any text entered against the item on the Inventory master file.
	Description	The description of the item you are inquiring on.
	Preferred Supplier	The preferred supplier for this item.
	Product Category	The product category for this item. This provides an alternative means of grouping items for discounts, reports and inquiries. For more information, refer to "File - Product Category".
	Class	The item's class. This provides an additional alternative means of grouping items for reporting/inquiries.
	GST/Sales Tax	The GST or sales tax table and percentage applicable to the item.
	Packs Per Carton	The number of packs per carton if the item has been setup to be tracked in both packs and units per pack. For example, a carton of beer might contain 24 cans, so a value of 20:08 would mean 20 cartons of beer and 8 individual bottles are in stock.
	ReOrder Quantity	Micronet displays the reorder quantity for this item as set on the Item Update screen - Purchasing tab – see "File - Inventory - Purchasing".
	Sales Unit	The quantity in which the item is sold.
	Units of Measure	The unit in which the item is measured, e.g. EA (each), LM (lineal metres), SM or M2 (square metres), cartons, etc.
	Last Sales Date	The date on which this item was last sold.
	Last Invoice	The invoice number on which this item was last supplied.
	Sales Quantity	The month to date and year to date quantity of sales for the item.
	Sales Value	The month to date and year to date value of sales for the item.
	Consumed Quantity
	Consumed Value
	Inquiry Cost	This field is only displayed if you have been given the appropriate access in the Show Cost on Inquiries field in your user ID (refer to "Maintenance - Edit UserIDs - 1. Main"). If so, it displays the default buy price set against your user ID, which is also displayed in the field name, e.g. Average Cost, Last Buy or a specific buy price.
	Last Buy (Ex)	This field is only displayed if you have been given the appropriate access in the Show Cost on Inquiries field in your user ID (refer to "Maintenance - Edit UserIDs - 1. Main"). If so, it displays the last buy price, excluding GST.
	Qty Breaks	The sell price breaks for the item and the price for each break.
	TOTAL / [Warehouse]	The fields in the bottom section of the screen display the current stock availability of the selected item with the TOTAL of all warehouses shown first. You can Tab to this section to search through the individual warehouses displayed.
	Bin	The warehouse bin in which the stock is held.
	On Hand	The quantity of the item on hand in each warehouse and in TOTAL.
	Backorder	The quantity of the item included in backorders in each warehouse and in TOTAL.
	B/O Allocation	The quantity of the item included in backorders that have been allocated for invoicing in each warehouse and in TOTAL.
	Held	The quantity of the item included in held invoices in each warehouse and in TOTAL.
	Picking Slip	The quantity of the item included in picking slips in each warehouse and in TOTAL.
	Completed Slip	2.8 Feature The quantity of the item included in completed paperless slips in each warehouse and in TOTAL.
	Batched Invoice	The quantity of the item included in batched invoices in each warehouse and in TOTAL.
	POS Docket	The quantity of the item included in orders held within the POS system for each warehouse and in TOTAL.
	Total On Hold	The quantity of the item included in invoices for on-hold debtors in each warehouse and in TOTAL.
	Stock Transfer	The quantity of the item included in stock transfers for each warehouse and in TOTAL.
	Purchase Order	The quantity of the item included in outstanding purchase orders for each warehouse and in TOTAL.
	Components	The quantity of the item included as a component on a manufactured job in MJC, or in a works order or kit, and in TOTAL.
	Consignment
	W/O or Job	The quantity of the item included in works orders held in MRF or jobs held in MJC (including kitted items), for each warehouse and in TOTAL.
	In Bound	The quantity of the item included in inbound transfers of stock to each warehouse and in TOTAL. This figure is updated when you hold a manually created stock transfer batch (refer to "Stock Transfer Creation - File - Hold"), or when Micronet automatically creates a transfer batch and the batch remains unposted. The In Bound value is updated for the final destination warehouse to show the number of items being transferred to that warehouse. If the Transfer To warehouse is a transit location, the In Bound value is updated for the warehouse that has the transit location assigned to it.
	Total Free Stock	The free stock quantity of the item in each warehouse and in TOTAL.
	Name	The warehouse name. You can move this field to the beginning of the list if required.

You can change the order in which the items at the bottom of the screen are sorted by double clicking on the header of the column you want to sort by.

For example, you can double click on the Bin column header to sort by bin number, or double click on the first column header [Warehouse] to sort by warehouse ID. You can only sort on selected columns. Micronet saves this change so items are sorted in that order the next time you display this screen.

You can also change the order in which the columns are displayed by selecting the column header and dragging the column to the position you want it in.

Micronet also saves this change so the screen always displays this way.

Optionally, you can double click on any of the lines in the bottom section of the screen to display or print a Stock on Hand report for the item.

You can also select a line and press Enter.

Micronet displays the Select Output Device screen where you can select whether you want the report displayed on screen, printed, saved to a specific type of file, faxed, or emailed in a specific format.

Reference

For more details on these options, refer to "Selecting the Output for Inquiries and Reports".

Micronet displays the Stock on Hand - Item report.

Select the Exit button when you have finished.

Optionally, press the F11 hotkey (or Alt+F6 in v2.7 only) to display an item summary.

Select the Exit button when you have finished.

The Item Inquiry screen also provides a large number of menu options, allowing you to perform many different types of inquiries on items in Micronet. If required, you can perform the following types of inquiries:

inquiries on the item's purchasing details, stock on hand, alternate parts and suppliers, and budgets - refer to "Item Inquiry - Inquiry"
inquiries where the item is reported in groups such as by backorder, picking slip, POS docket, stock transfer, standing order or quote - refer to "Item Inquiry - Dissection"
inquiries on the item's history in areas such as sales, purchases, transfers, budget, and lost sales - refer to "Item Inquiry - History"
inquiries on the item's prices including buy prices, sell prices, price breaks, special prices and contract prices - refer to "Item Inquiry - Prices"
MRF inquiries - refer to "Item Inquiry - MRF"
inquiries on kits and kit components - refer to "Item Inquiry - Kitting".